package com.talent.study.hello;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @Author: hszhou
 * @Date: 2025/6/5 16:02
 * @Description: 必须描述类做什么事情, 实现什么功能
 */
@AllArgsConstructor
@NoArgsConstructor
@JsonIgnoreProperties(ignoreUnknown = true) // 忽略未知字段
@Data
public class Demo {

    @ExcelProperty(value = "证书编号",index = 0)
    @ColumnWidth(20)
    private String certinum;
    @ColumnWidth(40)
    @ExcelProperty(value = "申请人",index = 1)
    private String appname;
    @ExcelProperty(value = "制造商",index = 2)
    @ColumnWidth(40)
    private String manuname;
    @ExcelProperty(value = "生产商",index = 3)
    @ColumnWidth(40)
    private String facname;
    @ExcelProperty(value = "产品名称",index = 4)
    @ColumnWidth(40)
    private String product;
    @ExcelProperty(value = "型号/规格",index = 5)
    @ColumnWidth(40)
    private String model;
    @ExcelProperty(value = "标准",index = 6)
    @ColumnWidth(15)
    private String teststandard;
    @ExcelProperty(value = "发证日期",index = 7,converter = TimeConverter.class)
    @ColumnWidth(15)
    private Long issuedate;
    @ExcelProperty(value = "首次发证日期",index = 8,converter = TimeConverter.class)
    @ColumnWidth(15)
    private Long originalIssueDate;
    @ExcelProperty(value = "有效期至",index = 9,converter = TimeConverter.class)
    @ColumnWidth(20)
    private Long expireddate;
    @ColumnWidth(20)
    @ExcelProperty(value = "现状态",index = 10,converter = StatusConverter.class)
    private Integer certistatus;


}
